﻿if exists (select * from dbo.sysobjects where name = 'sp_Work_Insert')	drop procedure [dbo].[sp_Work_Insert]Go CREATE PROCEDURE dbo.sp_Work_Insert	@uID		int,	@Name		nvarchar(50),	@StartDate		datetime,	@EndDate		datetime,	@Date		datetime,	@Content		ntext,	@Detail		ntext,	@Status		nvarchar(50),	@Point		float,	@PointLD		float,	@PointLD_1		float,	@TotalPoint		floatAS	INSERT INTO [Work]([uID], [Name], [StartDate], [EndDate], [Date], [Content], [Detail], [Status], [Point], [PointLD], [PointLD_1], [TotalPoint])	VALUES(@uID, @Name, @StartDate, @EndDate, @Date, @Content, @Detail, @Status, @Point, @PointLD, @PointLD_1, @TotalPoint)Go 